####################### TP 2 - 21/10/04 ############################
 
DICT 			-> Tables des méta_données
DBA_USERS 		-> Table des utilisateurs
DBA_TABLEPACES 		-> Table des tablespaces
DBA_DATAFILES 		-> Liste des DATA_Files
DBA_TABLES 		-> 
DBA_FREE_SPACE 		-> Table décrivant l'espace libre dans les tablespaces
DBA_EXTENTS 		-> Table des Extents

SYS -> Utilisateurs possedant toutes les tables de la métabase

Pour les admins : ALTER TABLE Vandersarren DEFAULT TABLESPACE USERS;

1/ Select TableSpace_name, initial_extent, next_extent, pct_increase
	from DBA_TABLESPACES;

2/ Select TableSpace_name, FILE_ID, File_name, bytes, blocks
	from DBA_DATA_FILES
	where TABLESPACE_NAME = 'USERS';

USERS en majuscule car Oracle stock tous ses objets en majuscules.

4/ Select Table_name 
	from DBA_TABLES
	where OWNER = 'DECEUNINCK';

5/ Select USERNAME, DEFAULT_TABLESPACE, CREATED
	from DBA_USERS
	where CREATED >'10/10/2004';

6/ select TABLESPACE_NAME, SUM(blocks), SUM(BYTES)
	from DBA_FREE_SPACE
	group by TABLESPACE_NAME;

7/ select TABLESPACE_NAME, sum(blocks) 
	from DBA_EXTENTS
	group by TABLESPACE_NAME;

8/ select segment_NAME, sum(blocks)
	from dba_extents
	where segment_NAME='SERVEUR'
	group by segment_NAME;

9/ select SUM(BLOCKS) as Espace_total_utilisé, SUM(BYTES) / (1024*1024)
	from dba_extents;

10/ select Block_ID, sum(bytes) 
	from dba_free_space
	where tablespace_name='SYSTEM'
	group by Block_ID;

11/ select TableSpace_name, Block_ID, sum(bytes) 
	from dba_free_space
	group by TableSpace_name, Block_ID;

12/ select dba_data_files.file_name, dba_free_space.Block_ID, sum(dba_free_space.bytes) 
	from dba_free_space, dba_data_files
	where dba_free_space.tablespace_name = dba_data_files.tablespace_name and
		dba_free_space.tablespace_name='SYSTEM'  
		group by dba_data_files.file_name, Block_ID;
	

13/